Carbitrage_Profile

Dataset statistics

Number of variables	20
Number of observations	2290424
Missing cells	3494900
Missing cells (%)	7.6%
Duplicate rows	62785
Duplicate rows (%)	2.7%
Total size in memory	1.8 GiB
Average record size in memory	838.9 B

Variable types

Text	4
Numeric	7
Categorical	7
DateTime	1
URL	1

Alerts

Dataset has 62785 (2.7%) duplicate rows	Duplicates
`drive` is highly overall correlated with `type`	High correlation
`odometer` is highly overall correlated with `predicted_price` and 1 other fields	High correlation
`predicted_price` is highly overall correlated with `odometer` and 2 other fields	High correlation
`price` is highly overall correlated with `odometer` and 1 other fields	High correlation
`type` is highly overall correlated with `drive`	High correlation
`year` is highly overall correlated with `predicted_price`	High correlation
`title` is highly imbalanced (77.3%)	Imbalance
`fuel` is highly imbalanced (75.7%)	Imbalance
`transmission` is highly imbalanced (67.8%)	Imbalance
`make` has 47044 (2.1%) missing values	Missing
`predicted_price` has 577806 (25.2%) missing values	Missing
`residual` has 577806 (25.2%) missing values	Missing
`condition` has 369671 (16.1%) missing values	Missing
`model` has 192028 (8.4%) missing values	Missing
`paint` has 623480 (27.2%) missing values	Missing
`drive` has 672749 (29.4%) missing values	Missing
`type` has 434032 (18.9%) missing values	Missing

Reproduction

Analysis started	2024-12-02 18:35:13.286845
Analysis finished	2024-12-02 18:39:08.107901
Duration	3 minutes and 54.82 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

location
Text

Distinct	413
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	123.7 MiB

Length

Max length	15
Median length	13
Mean length	7.6498159
Min length	2

Characters and Unicode

Total characters	17521322
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	orlando
2nd row	atlanta
3rd row	siouxfalls
4th row	lasvegas
5th row	dallas

Value	Count	Frequency (%)
miami	203810	8.9%
sfbay	142771	6.2%
losangeles	104965	4.6%
phoenix	93158	4.1%
portland	65872	2.9%
seattle	65548	2.9%
sandiego	61523	2.7%
sacramento	57187	2.5%
orangecounty	51898	2.3%
dallas	48695	2.1%
Other values (403)	1394997	60.9%

Most occurring characters

Value	Count	Frequency (%)
a	2004700	11.4%
e	1667454	9.5%
n	1557938	8.9%
o	1491572	8.5%
s	1357311	7.7%
i	1251924	7.1%
l	1201582	6.9%
t	962888	5.5%
r	820300	4.7%
m	757930	4.3%
Other values (16)	4447723	25.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17521322	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2004700	11.4%
e	1667454	9.5%
n	1557938	8.9%
o	1491572	8.5%
s	1357311	7.7%
i	1251924	7.1%
l	1201582	6.9%
t	962888	5.5%
r	820300	4.7%
m	757930	4.3%
Other values (16)	4447723	25.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17521322	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2004700	11.4%
e	1667454	9.5%
n	1557938	8.9%
o	1491572	8.5%
s	1357311	7.7%
i	1251924	7.1%
l	1201582	6.9%
t	962888	5.5%
r	820300	4.7%
m	757930	4.3%
Other values (16)	4447723	25.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17521322	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2004700	11.4%
e	1667454	9.5%
n	1557938	8.9%
o	1491572	8.5%
s	1357311	7.7%
i	1251924	7.1%
l	1201582	6.9%
t	962888	5.5%
r	820300	4.7%
m	757930	4.3%
Other values (16)	4447723	25.4%

price
Real number (ℝ)

High correlation

Distinct	10765
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10589.42

Minimum	255
Maximum	74999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.5 MiB

Quantile statistics

Minimum	255
5-th percentile	1995
Q1	4250
median	7000
Q3	13000
95-th percentile	31500
Maximum	74999
Range	74744
Interquartile range (IQR)	8750

Descriptive statistics

Standard deviation	10235.364
Coefficient of variation (CV)	0.96656514
Kurtosis	7.7353662
Mean	10589.42
Median Absolute Deviation (MAD)	3500
Skewness	2.4679172
Sum	2.4254261 × 10¹⁰
Variance	1.0476267 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4500	52927	2.3%
3500	52178	2.3%
5500	49669	2.2%
6500	49295	2.2%
5000	42324	1.8%
7500	42297	1.8%
2500	40796	1.8%
8500	36915	1.6%
4000	36896	1.6%
3000	36063	1.6%
Other values (10755)	1851064	80.8%

Value	Count	Frequency (%)
255	1	< 0.1%
259	11	< 0.1%
260	3	< 0.1%
265	2	< 0.1%
269	3	< 0.1%
270	1	< 0.1%
275	29	< 0.1%
277	1	< 0.1%
279	1	< 0.1%
280	3	< 0.1%

Value	Count	Frequency (%)
74999	98	< 0.1%
74998	3	< 0.1%
74995	31	< 0.1%
74990	5	< 0.1%
74985	1	< 0.1%
74980	1	< 0.1%
74950	16	< 0.1%
74910	1	< 0.1%
74900	110	< 0.1%
74888	1	< 0.1%

odometer
Real number (ℝ)

High correlation

Distinct	179879
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	133452.78

Minimum	1001
Maximum	399999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.5 MiB

Quantile statistics

Minimum	1001
5-th percentile	30551.15
Q1	89789
median	131000
Q3	174000
95-th percentile	242150
Maximum	399999
Range	398998
Interquartile range (IQR)	84211

Descriptive statistics

Standard deviation	63758.95
Coefficient of variation (CV)	0.47776412
Kurtosis	0.27523691
Mean	133452.78
Median Absolute Deviation (MAD)	42000
Skewness	0.3818283
Sum	3.0566345 × 10¹¹
Variance	4.0652037 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200000	36830	1.6%
150000	30157	1.3%
160000	27103	1.2%
140000	25492	1.1%
180000	24918	1.1%
170000	24282	1.1%
130000	23842	1.0%
120000	21534	0.9%
100000	18619	0.8%
190000	18199	0.8%
Other values (179869)	2039448	89.0%

Value	Count	Frequency (%)
1001	6	< 0.1%
1003	2	< 0.1%
1004	4	< 0.1%
1005	3	< 0.1%
1006	5	< 0.1%
1007	3	< 0.1%
1008	9	< 0.1%
1009	3	< 0.1%
1010	10	< 0.1%
1012	1	< 0.1%

Value	Count	Frequency (%)
399999	4	< 0.1%
399990	1	< 0.1%
399896	1	< 0.1%
399842	1	< 0.1%
399788	1	< 0.1%
399700	1	< 0.1%
399699	1	< 0.1%
399695	1	< 0.1%
399600	1	< 0.1%
399559	1	< 0.1%

year
Real number (ℝ)

High correlation

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2008.2009

Minimum	1974
Maximum	2025
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	17.5 MiB

Quantile statistics

Minimum	1974
5-th percentile	1993
Q1	2004
median	2009
Q3	2014
95-th percentile	2019
Maximum	2025
Range	51
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.3771385
Coefficient of variation (CV)	0.0041714645
Kurtosis	1.9719509
Mean	2008.2009
Median Absolute Deviation (MAD)	5
Skewness	-1.0987996
Sum	4.5996314 × 10⁹
Variance	70.17645
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2013	130674	5.7%
2008	128567	5.6%
2007	127225	5.6%
2012	126240	5.5%
2014	120326	5.3%
2006	117439	5.1%
2011	115067	5.0%
2015	110476	4.8%
2010	104005	4.5%
2005	101884	4.4%
Other values (42)	1108521	48.4%

Value	Count	Frequency (%)
1974	4221	0.2%
1975	2951	0.1%
1976	4042	0.2%
1977	4653	0.2%
1978	5202	0.2%
1979	5979	0.3%
1980	3472	0.2%
1981	2949	0.1%
1982	3375	0.1%
1983	3689	0.2%

Value	Count	Frequency (%)
2025	240	< 0.1%
2024	4941	0.2%
2023	15980	0.7%
2022	23683	1.0%
2021	31404	1.4%
2020	37022	1.6%
2019	52737	2.3%
2018	64096	2.8%
2017	81557	3.6%
2016	93361	4.1%

long
Real number (ℝ)

Distinct	306755
Distinct (%)	13.4%
Missing	136
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-100.61135

Minimum	-177.00763
Maximum	142.12326
Zeros	1846
Zeros (%)	0.1%
Negative	2288416
Negative (%)	99.9%
Memory size	17.5 MiB

Quantile statistics

Minimum	-177.00763
5-th percentile	-122.6801
Q1	-118.3507
median	-97.9122
Q3	-80.9288
95-th percentile	-73.709983
Maximum	142.12326
Range	319.13089
Interquartile range (IQR)	37.4219

Descriptive statistics

Standard deviation	19.928225
Coefficient of variation (CV)	-0.19807134
Kurtosis	-0.18559081
Mean	-100.61135
Median Absolute Deviation (MAD)	18.4498
Skewness	-0.12791197
Sum	-2.3042896 × 10⁸
Variance	397.13414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-80.2926	5319	0.2%
-80.2264	5166	0.2%
-80.1407	3886	0.2%
-80.3165	3618	0.2%
-80.1157	3094	0.1%
-80.403	2943	0.1%
-80.4085	2652	0.1%
-80.1891	2583	0.1%
-80.2153	2566	0.1%
-80.2092	2491	0.1%
Other values (306745)	2255970	98.5%

Value	Count	Frequency (%)
-177.007631	1	< 0.1%
-175.869141	1	< 0.1%
-166.538642	1	< 0.1%
-166.1151	1	< 0.1%
-165.961268	1	< 0.1%
-162.7211	1	< 0.1%
-162.685547	1	< 0.1%
-161.990162	3	< 0.1%
-161.8749	2	< 0.1%
-159.8251	1	< 0.1%

Value	Count	Frequency (%)
142.12326	1	< 0.1%
139.6917	2	< 0.1%
139.3485	1	< 0.1%
136.8326	1	< 0.1%
128.838981	1	< 0.1%
127.7586	2	< 0.1%
127.0706	2	< 0.1%
126.9775	1	< 0.1%
126.92395	4	< 0.1%
120.5833	1	< 0.1%

lat
Real number (ℝ)

Distinct	306497
Distinct (%)	13.4%
Missing	136
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	36.578113

Minimum	-82.921058
Maximum	142.58258
Zeros	1852
Zeros (%)	0.1%
Negative	231
Negative (%)	< 0.1%
Memory size	17.5 MiB

Quantile statistics

Minimum	-82.921058
5-th percentile	25.983891
Q1	33.1101
median	36.963687
Q3	40.964616
95-th percentile	46.871
Maximum	142.58258
Range	225.50363
Interquartile range (IQR)	7.8545162

Descriptive statistics

Standard deviation	6.5174326
Coefficient of variation (CV)	0.17817848
Kurtosis	2.9795332
Mean	36.578113
Median Absolute Deviation (MAD)	3.9343865
Skewness	-0.29118532
Sum	83774412
Variance	42.476928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.8301	5319	0.2%
26.1122	5171	0.2%
26.0218	4218	0.2%
25.985	3841	0.2%
26.2785	3094	0.1%
26.152	2865	0.1%
25.6694	2652	0.1%
25.9894	2554	0.1%
26.2674	2487	0.1%
27.3215	2263	0.1%
Other values (306487)	2255824	98.5%

Value	Count	Frequency (%)
-82.921058	1	< 0.1%
-80.172912	1	< 0.1%
-75.747631	1	< 0.1%
-67.980238	1	< 0.1%
-66.787821	1	< 0.1%
-62.712724	1	< 0.1%
-62.428643	1	< 0.1%
-62.383597	1	< 0.1%
-60.319107	1	< 0.1%
-55.379769	1	< 0.1%

Value	Count	Frequency (%)
142.582577	1	< 0.1%
71.683788	1	< 0.1%
71.41821	1	< 0.1%
66.742308	1	< 0.1%
66.5656	1	< 0.1%
65.168	1	< 0.1%
65.0907	1	< 0.1%
65.07	17	< 0.1%
65.002647	1	< 0.1%
64.999013	1	< 0.1%

make
Text

Missing

Distinct	65
Distinct (%)	< 0.1%
Missing	47044
Missing (%)	2.1%
Memory size	118.8 MiB

Length

Max length	13
Median length	11
Mean length	5.8706425
Min length	3

Characters and Unicode

Total characters	13170082
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	freightliner
2nd row	buick
3rd row	chevrolet
4th row	pontiac
5th row	audi

Value	Count	Frequency (%)
ford	343923	15.2%
toyota	260562	11.5%
chevrolet	256525	11.4%
honda	161340	7.2%
nissan	129465	5.7%
jeep	92190	4.1%
bmw	84250	3.7%
mercedes-benz	69607	3.1%
gmc	68722	3.0%
ram	68650	3.0%
Other values (58)	720945	32.0%

Most occurring characters

Value	Count	Frequency (%)
o	1508165	11.5%
e	1243755	9.4%
a	1126233	8.6%
r	981529	7.5%
t	861336	6.5%
d	859238	6.5%
n	737347	5.6%
s	621338	4.7%
c	594419	4.5%
l	539122	4.1%
Other values (17)	4097600	31.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13170082	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	1508165	11.5%
e	1243755	9.4%
a	1126233	8.6%
r	981529	7.5%
t	861336	6.5%
d	859238	6.5%
n	737347	5.6%
s	621338	4.7%
c	594419	4.5%
l	539122	4.1%
Other values (17)	4097600	31.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13170082	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	1508165	11.5%
e	1243755	9.4%
a	1126233	8.6%
r	981529	7.5%
t	861336	6.5%
d	859238	6.5%
n	737347	5.6%
s	621338	4.7%
c	594419	4.5%
l	539122	4.1%
Other values (17)	4097600	31.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13170082	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	1508165	11.5%
e	1243755	9.4%
a	1126233	8.6%
r	981529	7.5%
t	861336	6.5%
d	859238	6.5%
n	737347	5.6%
s	621338	4.7%
c	594419	4.5%
l	539122	4.1%
Other values (17)	4097600	31.1%

title
Categorical

Imbalance

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	118.3 MiB

clean	2080940
rebuilt	103170
salvage	77702
lien	20006
missing	6687

Length

Max length	10
Median length	5
Mean length	5.1592312
Min length	4

Characters and Unicode

Total characters	11816827
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	clean
2nd row	clean
3rd row	rebuilt
4th row	clean
5th row	clean

Common Values

Value	Count	Frequency (%)
clean	2080940	90.9%
rebuilt	103170	4.5%
salvage	77702	3.4%
lien	20006	0.9%
missing	6687	0.3%
parts only	1919	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
clean	2080940	90.8%
rebuilt	103170	4.5%
salvage	77702	3.4%
lien	20006	0.9%
missing	6687	0.3%
parts	1919	0.1%
only	1919	0.1%

Most occurring characters

Value	Count	Frequency (%)
l	2283737	19.3%
e	2281818	19.3%
a	2238263	18.9%
n	2109552	17.9%
c	2080940	17.6%
i	136550	1.2%
t	105089	0.9%
r	105089	0.9%
u	103170	0.9%
b	103170	0.9%
Other values (8)	269449	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11816827	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	2283737	19.3%
e	2281818	19.3%
a	2238263	18.9%
n	2109552	17.9%
c	2080940	17.6%
i	136550	1.2%
t	105089	0.9%
r	105089	0.9%
u	103170	0.9%
b	103170	0.9%
Other values (8)	269449	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11816827	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	2283737	19.3%
e	2281818	19.3%
a	2238263	18.9%
n	2109552	17.9%
c	2080940	17.6%
i	136550	1.2%
t	105089	0.9%
r	105089	0.9%
u	103170	0.9%
b	103170	0.9%
Other values (8)	269449	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11816827	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	2283737	19.3%
e	2281818	19.3%
a	2238263	18.9%
n	2109552	17.9%
c	2080940	17.6%
i	136550	1.2%
t	105089	0.9%
r	105089	0.9%
u	103170	0.9%
b	103170	0.9%
Other values (8)	269449	2.3%

predicted_price
Real number (ℝ)

High correlation Missing

Distinct	881482
Distinct (%)	51.5%
Missing	577806
Missing (%)	25.2%
Infinite	0
Infinite (%)	0.0%
Mean	9636.5497

Minimum	-121819.73
Maximum	175218.63
Zeros	0
Zeros (%)	0.0%
Negative	34034
Negative (%)	1.5%
Memory size	17.5 MiB

Quantile statistics

Minimum	-121819.73
5-th percentile	1318.9146
Q1	3974.4492
median	6950.429
Q3	12119.948
95-th percentile	27921.64
Maximum	175218.63
Range	297038.36
Interquartile range (IQR)	8145.4984

Descriptive statistics

Standard deviation	9228.5677
Coefficient of variation (CV)	0.95766306
Kurtosis	10.302222
Mean	9636.5497
Median Absolute Deviation (MAD)	3584.9327
Skewness	2.5019846
Sum	1.6503729 × 10¹⁰
Variance	85166462
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5963.142062	365	< 0.1%
5206.482999	325	< 0.1%
12464.03675	310	< 0.1%
5614.342006	215	< 0.1%
4978.933092	185	< 0.1%
7479.966291	177	< 0.1%
6482.27056	165	< 0.1%
28340.80192	165	< 0.1%
15873.14682	163	< 0.1%
7034.002231	155	< 0.1%
Other values (881472)	1710393	74.7%
(Missing)	577806	25.2%

Value	Count	Frequency (%)
-121819.73	1	< 0.1%
-112894.7437	2	< 0.1%
-110346.7735	1	< 0.1%
-87851.72981	1	< 0.1%
-79342.24351	1	< 0.1%
-79129.65846	1	< 0.1%
-76550.57958	5	< 0.1%
-70779.46514	1	< 0.1%
-68658.36891	1	< 0.1%
-68222.09689	1	< 0.1%

Value	Count	Frequency (%)
175218.6349	1	< 0.1%
174149.3679	1	< 0.1%
166346.281	1	< 0.1%
163898.331	1	< 0.1%
145138.8127	1	< 0.1%
137544.701	1	< 0.1%
136504.9896	1	< 0.1%
135853.7222	1	< 0.1%
132849.0895	1	< 0.1%
132441.7556	1	< 0.1%

residual
Real number (ℝ)

Missing

Distinct	1250957
Distinct (%)	73.0%
Missing	577806
Missing (%)	25.2%
Infinite	0
Infinite (%)	0.0%
Mean	930.84842

Minimum	-173528.63
Maximum	145629.66
Zeros	0
Zeros (%)	0.0%
Negative	701065
Negative (%)	30.6%
Memory size	17.5 MiB

Quantile statistics

Minimum	-173528.63
5-th percentile	-5636.294
Q1	-1118.6769
median	542.07632
Q3	2474.398
95-th percentile	9099.9732
Maximum	145629.66
Range	319158.29
Interquartile range (IQR)	3593.0749

Descriptive statistics

Standard deviation	5451.9053
Coefficient of variation (CV)	5.8569207
Kurtosis	23.218567
Mean	930.84842
Median Absolute Deviation (MAD)	1781.6379
Skewness	0.64006142
Sum	1.5941878 × 10⁹
Variance	29723272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16035.96325	306	< 0.1%
1420.033709	175	< 0.1%
526.8579378	170	< 0.1%
93.517001	165	< 0.1%
1026.853182	160	< 0.1%
-13208.73135	140	< 0.1%
430.6721447	135	< 0.1%
-502.4700821	135	< 0.1%
1902.713124	132	< 0.1%
-7724.816742	125	< 0.1%
Other values (1250947)	1710975	74.7%
(Missing)	577806	25.2%

Value	Count	Frequency (%)
-173528.6349	1	< 0.1%
-172649.3679	1	< 0.1%
-143448.8127	1	< 0.1%
-129441.7556	1	< 0.1%
-117888.2509	1	< 0.1%
-116762.4411	1	< 0.1%
-105853.7222	1	< 0.1%
-99356.95753	1	< 0.1%
-97346.28101	1	< 0.1%
-96898.33099	1	< 0.1%

Value	Count	Frequency (%)
145629.6585	1	< 0.1%
127894.7437	2	< 0.1%
123819.73	1	< 0.1%
113050.5796	5	< 0.1%
111096.7735	1	< 0.1%
105351.7298	1	< 0.1%
97458.36891	1	< 0.1%
97068.20604	1	< 0.1%
91842.24351	1	< 0.1%
81779.46514	1	< 0.1%

time_posted
Date

Distinct	1856420
Distinct (%)	81.1%
Missing	0
Missing (%)	0.0%
Memory size	17.5 MiB

Minimum	2023-12-03 08:00:27+00:00
Maximum	2024-12-01 20:08:47+00:00

Histogram with fixed size bins (bins=50)

condition
Categorical

Missing

Distinct	6
Distinct (%)	< 0.1%
Missing	369671
Missing (%)	16.1%
Memory size	121.6 MiB

excellent	806283
good	713692
like new	232055
fair	143875
salvage	13279

Length

Max length	9
Median length	8
Mean length	6.5968477
Min length	3

Characters and Unicode

Total characters	12670915
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	good
2nd row	excellent
3rd row	like new
4th row	excellent
5th row	good

Common Values

Value	Count	Frequency (%)
excellent	806283	35.2%
good	713692	31.2%
like new	232055	10.1%
fair	143875	6.3%
salvage	13279	0.6%
new	11569	0.5%
(Missing)	369671	16.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
excellent	806283	37.5%
good	713692	33.2%
new	243624	11.3%
like	232055	10.8%
fair	143875	6.7%
salvage	13279	0.6%

Most occurring characters

Value	Count	Frequency (%)
e	2907807	22.9%
l	1857900	14.7%
o	1427384	11.3%
n	1049907	8.3%
x	806283	6.4%
c	806283	6.4%
t	806283	6.4%
g	726971	5.7%
d	713692	5.6%
i	375930	3.0%
Other values (8)	1192475	9.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12670915	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2907807	22.9%
l	1857900	14.7%
o	1427384	11.3%
n	1049907	8.3%
x	806283	6.4%
c	806283	6.4%
t	806283	6.4%
g	726971	5.7%
d	713692	5.6%
i	375930	3.0%
Other values (8)	1192475	9.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12670915	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2907807	22.9%
l	1857900	14.7%
o	1427384	11.3%
n	1049907	8.3%
x	806283	6.4%
c	806283	6.4%
t	806283	6.4%
g	726971	5.7%
d	713692	5.6%
i	375930	3.0%
Other values (8)	1192475	9.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12670915	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2907807	22.9%
l	1857900	14.7%
o	1427384	11.3%
n	1049907	8.3%
x	806283	6.4%
c	806283	6.4%
t	806283	6.4%
g	726971	5.7%
d	713692	5.6%
i	375930	3.0%
Other values (8)	1192475	9.4%

url
URL

Distinct	1998952
Distinct (%)	87.3%
Missing	0
Missing (%)	0.0%
Memory size	297.4 MiB

https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html	110
https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html	95
https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html	95
https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html	95
https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html	90
Other values (1998947)	2289939

Value	Count	Frequency (%)
https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html	110	< 0.1%
https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html	95	< 0.1%
https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html	95	< 0.1%
https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html	95	< 0.1%
https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html	90	< 0.1%
https://miami.craigslist.org/mdc/cto/d/miami-2011-ford-mustang/7760134705.html	90	< 0.1%
https://miami.craigslist.org/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html	85	< 0.1%
https://miami.craigslist.org/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html	85	< 0.1%
https://miami.craigslist.org/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html	85	< 0.1%
https://miami.craigslist.org/mdc/cto/d/hallandale-hyundai-sonata-2017/7755236994.html	80	< 0.1%
Other values (1998942)	2289514	> 99.9%

Value	Count	Frequency (%)
https	2290424	100.0%

Value	Count	Frequency (%)
miami.craigslist.org	203815	8.9%
sfbay.craigslist.org	142970	6.2%
losangeles.craigslist.org	104976	4.6%
phoenix.craigslist.org	93184	4.1%
portland.craigslist.org	65886	2.9%
seattle.craigslist.org	65580	2.9%
sandiego.craigslist.org	61539	2.7%
sacramento.craigslist.org	57269	2.5%
orangecounty.craigslist.org	51898	2.3%
dallas.craigslist.org	48703	2.1%
Other values (405)	1394604	60.9%

Value	Count	Frequency (%)
/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html	110	< 0.1%
/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html	95	< 0.1%
/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html	95	< 0.1%
/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html	95	< 0.1%
/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html	90	< 0.1%
/mdc/cto/d/miami-2011-ford-mustang/7760134705.html	90	< 0.1%
/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html	85	< 0.1%
/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html	85	< 0.1%
/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html	85	< 0.1%
/mdc/cto/d/hallandale-hyundai-sonata-2017/7755236994.html	80	< 0.1%
Other values (1998942)	2289514	> 99.9%

Value	Count	Frequency (%)
	2290424	100.0%

Value	Count	Frequency (%)
	2290424	100.0%

state
Text

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	125.5 MiB

Length

Max length	20
Median length	14
Mean length	8.4478939
Min length	4

Characters and Unicode

Total characters	19349259
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Florida
2nd row	Georgia
3rd row	South Dakota
4th row	Nevada
5th row	Texas

Value	Count	Frequency (%)
california	542610	21.0%
florida	295453	11.4%
new	177884	6.9%
texas	152277	5.9%
arizona	128754	5.0%
washington	104607	4.0%
oregon	102795	4.0%
york	95515	3.7%
colorado	76948	3.0%
carolina	59556	2.3%
Other values (45)	853078	32.9%

Most occurring characters

Value	Count	Frequency (%)
a	2683483	13.9%
i	2413530	12.5%
o	2010117	10.4%
n	1582668	8.2%
r	1552795	8.0%
l	1172578	6.1%
e	902435	4.7%
s	802271	4.1%
C	718589	3.7%
f	565667	2.9%
Other values (36)	4945126	25.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19349259	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2683483	13.9%
i	2413530	12.5%
o	2010117	10.4%
n	1582668	8.2%
r	1552795	8.0%
l	1172578	6.1%
e	902435	4.7%
s	802271	4.1%
C	718589	3.7%
f	565667	2.9%
Other values (36)	4945126	25.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19349259	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2683483	13.9%
i	2413530	12.5%
o	2010117	10.4%
n	1582668	8.2%
r	1552795	8.0%
l	1172578	6.1%
e	902435	4.7%
s	802271	4.1%
C	718589	3.7%
f	565667	2.9%
Other values (36)	4945126	25.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19349259	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2683483	13.9%
i	2413530	12.5%
o	2010117	10.4%
n	1582668	8.2%
r	1552795	8.0%
l	1172578	6.1%
e	902435	4.7%
s	802271	4.1%
C	718589	3.7%
f	565667	2.9%
Other values (36)	4945126	25.6%

model
Text

Missing

Distinct	1287
Distinct (%)	0.1%
Missing	192028
Missing (%)	8.4%
Memory size	115.2 MiB

Length

Max length	31
Median length	26
Mean length	5.6316782
Min length	1

Characters and Unicode

Total characters	11817491
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	< 0.1%

Sample

1st row	sprinter 2500
2nd row	encore
3rd row	colorado
4th row	solstice
5th row	q5

Value	Count	Frequency (%)
1500	72009	3.2%
f150	69513	3.1%
silverado	53250	2.3%
camry	45510	2.0%
accord	44643	2.0%
r	41880	1.8%
2500	41112	1.8%
civic	39560	1.7%
wrangler	38069	1.7%
f250	31990	1.4%
Other values (940)	1789701	78.9%

Most occurring characters

Value	Count	Frequency (%)
a	1197265	10.1%
r	1162904	9.8%
e	1025594	8.7%
o	740805	6.3%
c	683820	5.8%
t	610484	5.2%
s	601543	5.1%
i	570802	4.8%
n	560962	4.7%
0	512209	4.3%
Other values (33)	4151103	35.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11817491	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1197265	10.1%
r	1162904	9.8%
e	1025594	8.7%
o	740805	6.3%
c	683820	5.8%
t	610484	5.2%
s	601543	5.1%
i	570802	4.8%
n	560962	4.7%
0	512209	4.3%
Other values (33)	4151103	35.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11817491	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1197265	10.1%
r	1162904	9.8%
e	1025594	8.7%
o	740805	6.3%
c	683820	5.8%
t	610484	5.2%
s	601543	5.1%
i	570802	4.8%
n	560962	4.7%
0	512209	4.3%
Other values (33)	4151103	35.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11817491	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1197265	10.1%
r	1162904	9.8%
e	1025594	8.7%
o	740805	6.3%
c	683820	5.8%
t	610484	5.2%
s	601543	5.1%
i	570802	4.8%
n	560962	4.7%
0	512209	4.3%
Other values (33)	4151103	35.1%

paint
Categorical

Missing

Distinct	12
Distinct (%)	< 0.1%
Missing	623480
Missing (%)	27.2%
Memory size	118.8 MiB

white	409252
black	290438
silver	238523
grey	215967
blue	179710
Other values (7)	333054

Length

Max length	6
Median length	5
Mean length	4.7566985
Min length	3

Characters and Unicode

Total characters	7929150
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	white
2nd row	red
3rd row	brown
4th row	green
5th row	custom

Common Values

Value	Count	Frequency (%)
white	409252	17.9%
black	290438	12.7%
silver	238523	10.4%
grey	215967	9.4%
blue	179710	7.8%
red	157710	6.9%
green	60055	2.6%
brown	48285	2.1%
custom	36398	1.6%
yellow	15178	0.7%
Other values (2)	15428	0.7%
(Missing)	623480	27.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
white	409252	24.6%
black	290438	17.4%
silver	238523	14.3%
grey	215967	13.0%
blue	179710	10.8%
red	157710	9.5%
green	60055	3.6%
brown	48285	2.9%
custom	36398	2.2%
yellow	15178	0.9%
Other values (2)	15428	0.9%

Most occurring characters

Value	Count	Frequency (%)
e	1351878	17.0%
l	744883	9.4%
r	735968	9.3%
i	647775	8.2%
b	518433	6.5%
w	472715	6.0%
t	445650	5.6%
h	409252	5.2%
c	326836	4.1%
a	300010	3.8%
Other values (11)	1975750	24.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7929150	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1351878	17.0%
l	744883	9.4%
r	735968	9.3%
i	647775	8.2%
b	518433	6.5%
w	472715	6.0%
t	445650	5.6%
h	409252	5.2%
c	326836	4.1%
a	300010	3.8%
Other values (11)	1975750	24.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7929150	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1351878	17.0%
l	744883	9.4%
r	735968	9.3%
i	647775	8.2%
b	518433	6.5%
w	472715	6.0%
t	445650	5.6%
h	409252	5.2%
c	326836	4.1%
a	300010	3.8%
Other values (11)	1975750	24.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7929150	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1351878	17.0%
l	744883	9.4%
r	735968	9.3%
i	647775	8.2%
b	518433	6.5%
w	472715	6.0%
t	445650	5.6%
h	409252	5.2%
c	326836	4.1%
a	300010	3.8%
Other values (11)	1975750	24.9%

fuel
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	12
Missing (%)	< 0.1%
Memory size	114.2 MiB

gas	2083719
diesel	129600
hybrid	50482
electric	21067
other	5544

Length

Max length	8
Median length	3
Mean length	3.2867034
Min length	3

Characters and Unicode

Total characters	7527905
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	diesel
2nd row	gas
3rd row	gas
4th row	gas
5th row	gas

Common Values

Value	Count	Frequency (%)
gas	2083719	91.0%
diesel	129600	5.7%
hybrid	50482	2.2%
electric	21067	0.9%
other	5544	0.2%
(Missing)	12	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gas	2083719	91.0%
diesel	129600	5.7%
hybrid	50482	2.2%
electric	21067	0.9%
other	5544	0.2%

Most occurring characters

Value	Count	Frequency (%)
s	2213319	29.4%
g	2083719	27.7%
a	2083719	27.7%
e	306878	4.1%
i	201149	2.7%
d	180082	2.4%
l	150667	2.0%
r	77093	1.0%
h	56026	0.7%
y	50482	0.7%
Other values (4)	124771	1.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7527905	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	2213319	29.4%
g	2083719	27.7%
a	2083719	27.7%
e	306878	4.1%
i	201149	2.7%
d	180082	2.4%
l	150667	2.0%
r	77093	1.0%
h	56026	0.7%
y	50482	0.7%
Other values (4)	124771	1.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7527905	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	2213319	29.4%
g	2083719	27.7%
a	2083719	27.7%
e	306878	4.1%
i	201149	2.7%
d	180082	2.4%
l	150667	2.0%
r	77093	1.0%
h	56026	0.7%
y	50482	0.7%
Other values (4)	124771	1.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7527905	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	2213319	29.4%
g	2083719	27.7%
a	2083719	27.7%
e	306878	4.1%
i	201149	2.7%
d	180082	2.4%
l	150667	2.0%
r	77093	1.0%
h	56026	0.7%
y	50482	0.7%
Other values (4)	124771	1.7%

drive
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	672749
Missing (%)	29.4%
Memory size	116.2 MiB

4wd	643667
fwd	572393
rwd	401615

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	4853025
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fwd
2nd row	4wd
3rd row	4wd
4th row	4wd
5th row	fwd

Common Values

Value	Count	Frequency (%)
4wd	643667	28.1%
fwd	572393	25.0%
rwd	401615	17.5%
(Missing)	672749	29.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4wd	643667	39.8%
fwd	572393	35.4%
rwd	401615	24.8%

Most occurring characters

Value	Count	Frequency (%)
w	1617675	33.3%
d	1617675	33.3%
4	643667	13.3%
f	572393	11.8%
r	401615	8.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4853025	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
w	1617675	33.3%
d	1617675	33.3%
4	643667	13.3%
f	572393	11.8%
r	401615	8.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4853025	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
w	1617675	33.3%
d	1617675	33.3%
4	643667	13.3%
f	572393	11.8%
r	401615	8.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4853025	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
w	1617675	33.3%
d	1617675	33.3%
4	643667	13.3%
f	572393	11.8%
r	401615	8.3%

type
Categorical

High correlation Missing

Distinct	14
Distinct (%)	< 0.1%
Missing	434032
Missing (%)	18.9%
Memory size	118.8 MiB

SUV	502396
sedan	502343
pickup	236256
truck	150495
coupe	101984
Other values (9)	362918

Length

Max length	11
Median length	9
Mean length	5.0273207
Min length	3

Characters and Unicode

Total characters	9332678
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	van
2nd row	truck
3rd row	SUV
4th row	SUV
5th row	SUV

Common Values

Value	Count	Frequency (%)
SUV	502396	21.9%
sedan	502343	21.9%
pickup	236256	10.3%
truck	150495	6.6%
coupe	101984	4.5%
hatchback	100873	4.4%
convertible	72582	3.2%
van	70396	3.1%
minivan	49180	2.1%
wagon	33466	1.5%
Other values (4)	36421	1.6%
(Missing)	434032	18.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
suv	502396	27.1%
sedan	502343	27.1%
pickup	236256	12.7%
truck	150495	8.1%
coupe	101984	5.5%
hatchback	100873	5.4%
convertible	72582	3.9%
van	70396	3.8%
minivan	49180	2.6%
wagon	33466	1.8%
Other values (4)	36421	2.0%

Most occurring characters

Value	Count	Frequency (%)
a	870503	9.3%
n	785851	8.4%
e	768343	8.2%
c	763063	8.2%
p	574496	6.2%
d	511363	5.5%
s	506540	5.4%
S	502396	5.4%
V	502396	5.4%
U	502396	5.4%
Other values (15)	3045331	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9332678	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	870503	9.3%
n	785851	8.4%
e	768343	8.2%
c	763063	8.2%
p	574496	6.2%
d	511363	5.5%
s	506540	5.4%
S	502396	5.4%
V	502396	5.4%
U	502396	5.4%
Other values (15)	3045331	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9332678	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	870503	9.3%
n	785851	8.4%
e	768343	8.2%
c	763063	8.2%
p	574496	6.2%
d	511363	5.5%
s	506540	5.4%
S	502396	5.4%
V	502396	5.4%
U	502396	5.4%
Other values (15)	3045331	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9332678	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	870503	9.3%
n	785851	8.4%
e	768343	8.2%
c	763063	8.2%
p	574496	6.2%
d	511363	5.5%
s	506540	5.4%
S	502396	5.4%
V	502396	5.4%
U	502396	5.4%
Other values (15)	3045331	32.6%

transmission
Categorical

Imbalance

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	126.0 MiB

automatic	2056290
manual	219656
other	14478

Length

Max length	9
Median length	9
Mean length	8.6870099
Min length	5

Characters and Unicode

Total characters	19896936
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	automatic
2nd row	automatic
3rd row	automatic
4th row	automatic
5th row	automatic

Common Values

Value	Count	Frequency (%)
automatic	2056290	89.8%
manual	219656	9.6%
other	14478	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
automatic	2056290	89.8%
manual	219656	9.6%
other	14478	0.6%

Most occurring characters

Value	Count	Frequency (%)
a	4551892	22.9%
t	4127058	20.7%
u	2275946	11.4%
m	2275946	11.4%
o	2070768	10.4%
i	2056290	10.3%
c	2056290	10.3%
n	219656	1.1%
l	219656	1.1%
h	14478	0.1%
Other values (2)	28956	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19896936	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	4551892	22.9%
t	4127058	20.7%
u	2275946	11.4%
m	2275946	11.4%
o	2070768	10.4%
i	2056290	10.3%
c	2056290	10.3%
n	219656	1.1%
l	219656	1.1%
h	14478	0.1%
Other values (2)	28956	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19896936	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	4551892	22.9%
t	4127058	20.7%
u	2275946	11.4%
m	2275946	11.4%
o	2070768	10.4%
i	2056290	10.3%
c	2056290	10.3%
n	219656	1.1%
l	219656	1.1%
h	14478	0.1%
Other values (2)	28956	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19896936	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	4551892	22.9%
t	4127058	20.7%
u	2275946	11.4%
m	2275946	11.4%
o	2070768	10.4%
i	2056290	10.3%
c	2056290	10.3%
n	219656	1.1%
l	219656	1.1%
h	14478	0.1%
Other values (2)	28956	0.1%

	condition	drive	fuel	lat	long	odometer	paint	predicted_price	price	residual	title	transmission	type	year
condition	1.000	0.015	0.046	0.042	0.029	0.206	0.037	0.130	0.199	0.055	0.107	0.048	0.054	0.196
drive	0.015	1.000	0.139	0.097	0.038	0.090	0.105	0.111	0.195	0.066	0.057	0.073	0.516	0.207
fuel	0.046	0.139	1.000	0.019	0.046	0.121	0.069	0.094	0.149	0.073	0.026	0.175	0.243	0.109
lat	0.042	0.097	0.019	1.000	-0.121	0.064	0.012	-0.069	-0.032	0.090	0.052	0.028	0.025	-0.103
long	0.029	0.038	0.046	-0.121	1.000	-0.008	0.028	-0.004	-0.070	-0.134	0.062	0.029	0.045	0.074
odometer	0.206	0.090	0.121	0.064	-0.008	1.000	0.036	-0.615	-0.505	0.078	0.079	0.054	0.088	-0.375
paint	0.037	0.105	0.069	0.012	0.028	0.036	1.000	0.025	0.048	0.014	0.023	0.082	0.098	0.105
predicted_price	0.130	0.111	0.094	-0.069	-0.004	-0.615	0.025	1.000	0.820	-0.160	0.045	0.032	0.058	0.577
price	0.199	0.195	0.149	-0.032	-0.070	-0.505	0.048	0.820	1.000	0.323	0.072	0.029	0.097	0.476
residual	0.055	0.066	0.073	0.090	-0.134	0.078	0.014	-0.160	0.323	1.000	0.024	0.028	0.041	-0.034
title	0.107	0.057	0.026	0.052	0.062	0.079	0.023	0.045	0.072	0.024	1.000	0.034	0.039	0.103
transmission	0.048	0.073	0.175	0.028	0.029	0.054	0.082	0.032	0.029	0.028	0.034	1.000	0.193	0.197
type	0.054	0.516	0.243	0.025	0.045	0.088	0.098	0.058	0.097	0.041	0.039	0.193	1.000	0.113
year	0.196	0.207	0.109	-0.103	0.074	-0.375	0.105	0.577	0.476	-0.034	0.103	0.197	0.113	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	location	price	odometer	year	long	lat	make	title	predicted_price	residual	time_posted	condition	url	state	model	paint	fuel	drive	type	transmission
0	orlando	12800.0	260078.0	2015.0	-81.362200	28.393200	freightliner	clean	10037.289627	2762.710373	2024-11-28 11:14:15+00:00	good	https://orlando.craigslist.org/cto/d/orlando-sprinter-van/7805995081.html	Florida	sprinter 2500	white	diesel	fwd	van	automatic
1	atlanta	5500.0	116000.0	2016.0	-83.863200	34.296600	buick	clean	NaN	NaN	2024-11-27 10:04:06+00:00	None	https://atlanta.craigslist.org/nat/cto/d/gainesville-2016-buick-encore-sport/7805731876.html	Georgia	encore	None	gas	None	None	automatic
2	siouxfalls	16800.0	81100.0	2015.0	-96.310300	43.201400	chevrolet	rebuilt	16739.760658	60.239342	2024-11-27 07:15:17+00:00	excellent	https://siouxfalls.craigslist.org/cto/d/rock-valley-crew-cab-colorado/7805709785.html	South Dakota	colorado	red	gas	4wd	truck	automatic
3	lasvegas	7900.0	89000.0	2008.0	-116.932400	33.796700	pontiac	clean	NaN	NaN	2024-11-25 14:54:13+00:00	like new	https://lasvegas.craigslist.org/cto/d/san-jacinto-absolutely-mint-condition/7805324202.html	Nevada	solstice	None	gas	None	None	automatic
4	dallas	5950.0	138000.0	2012.0	-96.838500	32.960000	audi	clean	8045.831956	-2095.831956	2024-11-24 13:36:04+00:00	excellent	https://dallas.craigslist.org/dal/cto/d/addison-2012-audi-q5-loaded-138k-nice/7804985720.html	Texas	q5	brown	gas	None	SUV	automatic
5	sfbay	5900.0	129000.0	2005.0	-122.077500	37.405600	volkswagen	clean	2189.987651	3710.012349	2024-11-21 11:01:37+00:00	good	https://sfbay.craigslist.org/sby/cto/d/mountain-view-2005-volkswagen-touareg-v6/7804146640.html	California	touareg	green	gas	4wd	SUV	automatic
6	portland	4650.0	204000.0	2003.0	-123.504700	45.082600	nissan	clean	3604.553845	1045.446155	2024-11-19 09:30:51+00:00	excellent	https://portland.craigslist.org/yam/cto/d/willamina-03-nissan-pathfinder-le-4x4/7803524372.html	Oregon	pathfinder	custom	gas	4wd	SUV	automatic
7	miami	900.0	100000.0	2009.0	-80.292600	25.830100	dodge	clean	NaN	NaN	2024-11-07 12:36:31+00:00	None	https://miami.craigslist.org/mdc/cto/d/hialeah-2009-dodge-durango/7800091321.html	Florida	durango	None	gas	None	SUV	automatic
8	seattle	5699.0	123000.0	2009.0	-122.443485	48.790332	ford	clean	NaN	NaN	2024-11-05 14:30:48+00:00	None	https://seattle.craigslist.org/see/cto/d/bellingham-2009-ford-expedition-4x4/7799628737.html	Washington	expedition	None	gas	None	SUV	automatic
9	littlerock	6200.0	209085.0	2013.0	-92.210655	34.493909	toyota	clean	6647.499313	-447.499313	2024-11-05 11:51:33+00:00	excellent	https://littlerock.craigslist.org/cto/d/woodson-2013-prius-6200-obo/7799536266.html	Arkansas	prius c	red	hybrid	fwd	hatchback	automatic

	location	price	odometer	year	long	lat	make	title	predicted_price	residual	time_posted	condition	url	state	model	paint	fuel	drive	type	transmission
2290414	sfbay	6400.0	200300.0	2004.0	-121.1529	38.6709	chevrolet	clean	NaN	NaN	2024-04-18 13:34:02+00:00	None	https://sfbay.craigslist.org/sfc/cto/d/represa-2004-chevrolet-silverado-v6/7738514683.html	California	silverado 1500	None	gas	None	None	automatic
2290415	chicago	3500.0	198000.0	2006.0	-87.8387	41.9279	chevrolet	clean	5304.407288	-1804.407288	2024-03-08 14:20:05+00:00	good	https://chicago.craigslist.org/nch/cto/d/river-grove-2006-silverado-owner/7725231018.html	Illinois	silverado 1500	black	gas	rwd	truck	automatic
2290416	spacecoast	4900.0	200000.0	2007.0	-80.4030	27.3215	chevrolet	clean	NaN	NaN	2024-11-04 12:27:33+00:00	None	https://spacecoast.craigslist.org/cto/d/port-saint-lucie-2007-chevy-silverado/7799235343.html	Florida	silverado 1500	None	gas	None	pickup	automatic
2290417	vermont	6000.0	157000.0	2009.0	-71.8510	44.4380	chevrolet	clean	11220.309546	-5220.309546	2024-09-06 11:00:06+00:00	excellent	https://vermont.craigslist.org/cto/d/concord-chevorlet-silverado-09/7782320378.html	Vermont	silverado 1500	blue	gas	None	truck	automatic
2290418	sfbay	15900.0	74000.0	2012.0	-121.9530	37.3492	chevrolet	clean	19129.265004	-3229.265004	2024-07-27 11:26:05+00:00	excellent	https://sfbay.craigslist.org/sby/cto/d/santa-clara-2012-chevrolet-silverado/7770005116.html	California	silverado 1500	silver	gas	rwd	truck	automatic
2290419	losangeles	39000.0	32000.0	2020.0	-118.3295	33.8708	chevrolet	clean	NaN	NaN	2024-08-15 17:04:53+00:00	None	https://losangeles.craigslist.org/wst/cto/d/torrance-2020-chevrolet-silverado-1500/7775871256.html	California	silverado 1500	None	gas	None	pickup	automatic
2290420	sacramento	4800.0	220000.0	2003.0	-120.8517	37.5239	chevrolet	clean	6532.142742	-1732.142742	2024-10-31 11:48:58+00:00	excellent	https://sacramento.craigslist.org/cto/d/turlock-2003-chevy-step-side/7798185582.html	California	silverado 1500	black	gas	rwd	truck	manual
2290421	losangeles	17500.0	170000.0	1992.0	-118.3254	34.1005	chevrolet	clean	NaN	NaN	2024-09-12 18:23:49+00:00	None	https://losangeles.craigslist.org/lac/cto/d/los-angeles-1992-chevy-shortbed-pickup/7784298349.html	California	silverado 1500	None	gas	None	pickup	automatic
2290422	poconos	1500.0	160000.0	2003.0	-74.9380	41.2400	chevrolet	clean	NaN	NaN	2024-04-09 08:00:31+00:00	None	https://poconos.craigslist.org/cto/d/dingmans-ferry-chevy-silverado/7735510884.html	Pennsylvania	silverado 1500	None	gas	rwd	None	automatic
2290423	boone	30000.0	46900.0	2019.0	-81.1573	36.1359	chevrolet	clean	29318.781895	681.218105	2024-04-18 19:11:05+00:00	excellent	https://boone.craigslist.org/cto/d/wilkesboro-2019-silverado-ld-2wd/7738566141.html	North Carolina	silverado 1500	white	gas	rwd	truck	automatic

Most frequently occurring

	location	price	odometer	year	long	lat	make	title	predicted_price	residual	time_posted	condition	url	state	model	paint	fuel	drive	type	transmission	# duplicates
46175	miami	20900.0	88000.0	2018.0	-80.207000	25.851200	ford	clean	10834.580605	10065.419395	2024-07-02 14:44:10+00:00	like new	https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html	Florida	mustang	white	gas	rwd	convertible	automatic	110
11953	miami	1500.0	180000.0	2005.0	-80.142356	26.295185	scion	clean	2463.666613	-963.666613	2024-06-18 12:29:42+00:00	fair	https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html	Florida	xb	grey	gas	fwd	sedan	automatic	95
20925	miami	4500.0	146683.0	2012.0	-80.056000	26.618200	kia	clean	NaN	NaN	2024-07-02 13:40:53+00:00	NaN	https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html	Florida	rio	NaN	gas	NaN	sedan	automatic	95
33789	miami	8500.0	154000.0	2006.0	-80.084400	26.346200	gmc	clean	8067.815536	432.184464	2024-06-24 13:37:00+00:00	good	https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html	Florida	1500	grey	gas	rwd	pickup	automatic	95
17416	miami	3500.0	228000.0	2005.0	-80.358800	25.734300	lexus	clean	3637.888707	-137.888707	2024-06-28 11:07:17+00:00	good	https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html	Florida	ls	silver	gas	fwd	sedan	automatic	90
26002	miami	5900.0	101000.0	2011.0	-80.404600	25.596800	ford	rebuilt	10574.741723	-4674.741723	2024-06-24 21:56:57+00:00	like new	https://miami.craigslist.org/mdc/cto/d/miami-2011-ford-mustang/7760134705.html	Florida	mustang	black	gas	rwd	convertible	manual	90
13982	miami	2500.0	220000.0	2004.0	-80.195000	26.585000	bmw	clean	NaN	NaN	2024-06-08 08:51:23+00:00	NaN	https://miami.craigslist.org/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html	Florida	2	black	gas	NaN	sedan	automatic	85
37872	miami	10500.0	162000.0	2015.0	-80.380900	26.100300	lexus	clean	8396.419744	2103.580256	2024-06-23 22:39:29+00:00	good	https://miami.craigslist.org/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html	Florida	ct	silver	hybrid	NaN	hatchback	automatic	85
42685	miami	14900.0	44000.0	2019.0	-80.418629	25.598488	gmc	rebuilt	20529.461749	-5629.461749	2024-06-26 12:51:10+00:00	like new	https://miami.craigslist.org/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html	Florida	acadia	silver	gas	fwd	SUV	automatic	85
20077	miami	4300.0	129000.0	2010.0	-80.121300	26.263500	volkswagen	clean	5220.294134	-920.294134	2024-06-24 21:33:50+00:00	excellent	https://miami.craigslist.org/brw/cto/d/pompano-beach-2010-vw-jetta/7760130431.html	Florida	jetta	black	gas	NaN	sedan	automatic	80

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)